%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ include file="/common.inc" %>
<%@ include file="/login_check.inc" %>
<%
// POST 한글 파라미터 깨짐 처리
request.setCharacterEncoding("UTF-8");
// 사용할 객체 초기화
Connection conn = null;
PreparedStatement pstmt = null;
// 파라미터
String seq = request.getParameter("seq");
try {
// 데이터베이스 객체 생성
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ys", "srpinfotec", "srpinfotec1@#");
pstmt = conn.prepareStatement("DELETE FROM IMAGE where seq = ? ");
pstmt.setInt(1, Integer.parseInt(seq));
pstmt.executeUpdate();
pstmt = conn.prepareStatement("DELETE FROM IMAGE_FILES where up_seq = ? ");
pstmt.setInt(1, Integer.parseInt(seq));
pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
System.out.println(pstmt.toString());
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
response.sendRedirect("image_list.jsp?main_seq="+main_seq+"&sub_seq="+sub_seq+"&sub_sub_seq="+sub_sub_seq);
}
%>